This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
@Jens, we had the same issue and we were under the gun to provide a globally acceptable solution. In our case both the view indexes and the full text index were being used by the application, and as you probably have experienced, in extensive testing the server/application had no issues. What the business unit did of course was to say they wanted all the reports done on a certain day and time, thus HEAVY load on the server - which just stopped doing index and view updates. The application seemed to be operating fine, but returned stupid results. The business unit didn't care what happened to the data, or what process stopped, just that it was incorrect. The Domino processes that stopped working made us look like monkeys, and there was serious consideration to move the whole application away from Notes to Oracle/web custom development.
We then wrote a pile of code in our Notes app to take all the data out to Oracle, wrote another pile of code to take user selected parameters to execute a select statement on the Oracle data, and another pile of code to return the rows back into notes with the correct security enabled. Effectively we did our own rdbms enablement, but ALL CUSTOM for the application.
I guess the nsf is pretty cool, but wouldn't IBM have a real powerhouse application if it used an RDBMS natively. Just think of the numbers of Domino servers that would be installed if Domino could use MySQL or PostgreSQL! Can you also image what that would do to increase development productivity in any organization from SMB to corp development shops?
Feedback response number WEBB7NRQN3 created by ~Dana Chulumarflar on 01/29/2009